﻿CREATE PROCEDURE [dbo].[Doctor_Select]
	@ID int = NULL,
	@MemberID int =NULL ,
	@Name NVARCHAR(50) = null
AS
	SELECT *
	From[Doctor]
	Where 
	(
	(@ID IS NULL OR ID = @ID)AND
	(@MemberID IS NULL OR MemberID = @MemberID)AND
	(@Name is null or Name like @Name + '%')
	) 
	
